% Created 2021-05-04 Tue 19:42
% Intended LaTeX compiler: pdflatex
\documentclass[11pt]{article}
\usepackage[utf8]{inputenc}
\usepackage[T1]{fontenc}
\usepackage{graphicx}
\usepackage{grffile}
\usepackage{longtable}
\usepackage{wrapfig}
\usepackage{rotating}
\usepackage[normalem]{ulem}
\usepackage{amsmath}
\usepackage{textcomp}
\usepackage{amssymb}
\usepackage{capt-of}
\usepackage{hyperref}
\author{Liam Hurwitz}
\date{\today}
\title{Report}
\hypersetup{
 pdfauthor={Liam Hurwitz},
 pdftitle={Report},
 pdfkeywords={},
 pdfsubject={},
 pdfcreator={Emacs 27.2 (Org mode 9.5)}, 
 pdflang={English}}
\begin{document}

\maketitle
\tableofcontents

\section{Methoden}
\label{sec:org5fd39d6}
\subsection{Start by Gathering Data from Lobbypedia with the Crawl Script}
\label{sec:org6b38965}
\href{https://lobbypedia.de/wiki/Spezial:Abfrage\_ausf\%C3\%BChren/Parteispenden}{Database of Lobbypedia}
The Database takes to long to respond if you dont filter by year. This is what the crawler does

Start the Crawller by running
\begin{verbatim}
./crawl.sh
\end{verbatim}
You will see the curl output with the Current Year
\subsection{Adding Data from Open Corporate}
\label{sec:org93acec2}
\href{https://github.com/OpenRefine/OpenRefine/wiki/Reconciliation}{Wiki Entry}
\subsubsection{Reconcile Column for Corporate Spenders}
\label{sec:org4b1007b}
Click Geldgeber, Reconcile Data
Reconcile Corporation
Wait
Accept or Refuse

Edit Column based on this Columns
Add Matched Company Name
\begin{verbatim}
cell.recon.match.name
\end{verbatim}
Add URL of Open Corporates
\begin{verbatim}
"https://opencorporates.com" + cell.recon.match.id
\end{verbatim}

Then Disgard Reconcilliation Differences
GoogleRefine - Google Refine 2.0 - Data Augmentatio
\subsubsection{Extraction of Steps Openrefine}
\label{sec:orgd8d6fd6}
\begin{verbatim}
[
  {
    "op": "core/column-split",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Geldgeber",
    "guessCellType": true,
    "removeOriginalColumn": true,
    "mode": "separator",
    "separator": ", ",
    "regex": false,
    "maxColumns": 0,
    "description": "Split column Geldgeber by separator"
  },
  {
    "op": "core/text-transform",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Geldgeber 1",
    "expression": "join ([coalesce(cells['Geldgeber 1'].value,''),coalesce(cells['Geldgeber 2'].value,'')],' ')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10,
    "description": "Text transform on cells in column Geldgeber 1 using expression join ([coalesce(cells['Geldgeber 1'].value,''),coalesce(cells['Geldgeber 2'].value,'')],' ')"
  },
  {
    "op": "core/column-reorder",
    "columnNames": [
      "Column",
      "Geldgeber 1",
      "Geldgeber 3",
      "Kategorie",
      "Betrag",
      "Empfänger",
      "Jahr",
      "Ort",
      "Bundesland",
      "Branche",
      "Schlagworte"
    ],
    "description": "Reorder columns"
  },
  {
    "op": "core/column-rename",
    "oldColumnName": "Geldgeber 1",
    "newColumnName": "Geldgeber",
    "description": "Rename column Geldgeber 1 to Geldgeber"
  },
  {
    "op": "core/column-removal",
    "columnName": "Geldgeber 3",
    "description": "Remove column Geldgeber 3"
  }
]
\end{verbatim}
\begin{enumerate}
\item Question
\label{sec:org06d162f}
Geldgeber 3
\end{enumerate}

\subsection{Wikidata}
\label{sec:org1f78996}
\subsection{Neo4J import}
\label{sec:org146f919}
\href{https://neo4j.com/docs/cypher-manual/current/clauses/load-csv/}{Guid    e}
\href{https://neo4j.com/developer/guide-import-csv/}{Importing CSV   }
\subsubsection{Legal Entitys}
\label{sec:org4e1f1de}
\begin{verbatim}

CREATE CONSTRAINT ON (e:Entity) ASSERT e.name IS UNIQUE;
CREATE CONSTRAINT ON (e:Party) ASSERT e.name IS UNIQUE;
\end{verbatim}


\begin{verbatim}
CREATE INDEX FOR (n:Entity) ON (n.name);
CREATE INDEX FOR (n:Person) ON (n.name);
CREATE INDEX FOR (n:Party) ON (n.name);

\end{verbatim}
\begin{verbatim}


WITH "https://notabug.org/ProTransparenz/lobbywatch/raw/main/" AS base
WITH base + "juristische.csv" AS uri
LOAD CSV WITH HEADERS FROM uri as row with row
MERGE (source:Entity {name: row.Geldgeber, location: coalesce(row.Ort, "Unknown")})
MERGE (destination:Party {name: row.Empfänger})
MERGE (source)-[:DONATION {year: toInteger(row.Jahr), amount: toFloat(row.Betrag)}]-> (destination)
\end{verbatim}
\subsubsection{Natural Persons}
\label{sec:orgf02282f}
\begin{verbatim}
CREATE CONSTRAINT ON (e:Entity) ASSERT e.name IS UNIQUE;
CREATE INDEX FOR (n:Party) ON n.name

USING PERIODIC COMMIT 1000

WITH "https://notabug.org/ProTransparenz/lobbywatch/raw/main/" AS base
WITH base + "nat.csv" AS uri
LOAD CSV WITH HEADERS FROM uri as row with row
MERGE (source:Person {name: row.Geldgeber,  location: coalesce(row.Ort, "Unknown")})
MERGE (destination:Party {name: row.Empfänger})
MERGE (source)-[:DONATION {year: toInteger(row.Jahr), amount: toFloat(row.Betrag)}]-> (destination)
\end{verbatim}


Sum all Donations and save to person

\begin{verbatim}
MATCH (p:Person)-[r:DONATION]->()
total = SUM(r.amount)
RETURN total
\end{verbatim}

\subsubsection{Page Rank}
\label{sec:orgddb41ae}
Installation \href{https://graphaware.com/neo4j/2020/04/26/graph-datascience-neo4j-4.html}{Guide}

\url{https://neo4j.com/docs/graph-data-science/current/algorithms/page-rank/}

Write a native Projection and store it in the graph catalog
\begin{verbatim}
CALL gds.graph.create(
  'myGraph',
  'Person',
  'DONATION',
  {
    relationshipProperties: 'betrag'
  }
)
\end{verbatim}

\begin{verbatim}
CALL gds.pageRank.stream('myGraph', {
  maxIterations: 20,
  dampingFactor: 0.85,
  relationshipWeightProperty: 'betrag'
})
YIELD nodeId, score
RETURN gds.util.asNode(nodeId).name AS name, score
ORDER BY score DESC, name ASC
\end{verbatim}
\subsection{Visualize}
\label{sec:org1f5f6eb}
\subsubsection{Spenden aus 2016}
\label{sec:org3ac71e6}
\begin{verbatim}
MATCH p=()-[r:DONATION]->() WHERE r.year=2016 RETURN p LIMIT 1800
\end{verbatim}

\subsubsection{Summe der Spenden von Menschen}
\label{sec:org8a75f57}
\begin{verbatim}
MATCH (p:Person)-[r:DONATION]->()
WITH SUM(r.amount) as total
RETURN total
\end{verbatim}

\url{https://community.neo4j.com/t/how-to-increase-the-thickness-of-relationship-line-in-neo4j/708/3}
\subsubsection{Top 2500 Spenden von 2000 bis 2020}
\label{sec:org47ed4ba}
\begin{verbatim}
MATCH (n)-[r:DONATION]->(m) RETURN r, n, m ORDER BY r.amount DESC LIMIT 2500
\end{verbatim}
\subsubsection{Spenden nach Person}
\label{sec:orgaf2f483}
\begin{verbatim}
MATCH (n)-[r:DONATION]->(m) WHERE n.name CONTAINS 'Lindner' RETURN r, n, m ORDER BY r.amount DESC LIMIT 250
\end{verbatim}

\subsubsection{Tausend Größten Spenden an die AFD}
\label{sec:org842952b}
\begin{verbatim}
MATCH (n)-[r:DONATION]->(m:Party {name: 'CDU'}) RETURN n,r,m ORDER BY r.amount LIMIT 100
\end{verbatim}

\subsection{Front End}
\label{sec:org9209831}
\subsubsection{Screenshots}
\label{sec:orgb1b8a03}
\begin{enumerate}
\item Spenden nach Art
\label{sec:org567b296}
Welche Personen waren die Top Spender
\begin{center}
\includegraphics[width=.9\linewidth]{./bilder/front/topPersonnen.png}
\end{center}

Welche Firmen waren die größten Spender
\begin{center}
\includegraphics[width=.9\linewidth]{./bilder/front/topFirmen.png}
\end{center}
\item Spende nach Partei
\label{sec:orgbc7e631}
AFD
\begin{center}
\includegraphics[width=.9\linewidth]{./bilder/front/afd.png}
\end{center}

CDU
\begin{center}
\includegraphics[width=.9\linewidth]{./bilder/front/cdu.png}
\end{center}

\item Spenden nach Betrag
\label{sec:org7a85b57}
An wenn gingen die größten 200 Spenden
\begin{center}
\includegraphics[width=.9\linewidth]{./bilder/front/top20.png}
\end{center}

An wenn gingen die größten 200 Spenden
\begin{center}
\includegraphics[width=.9\linewidth]{./bilder/front/top200.png}
\end{center}

An wenn gingen die größten 200 Spenden
\begin{center}
\includegraphics[width=.9\linewidth]{./bilder/front/top200.png}
\end{center}
\end{enumerate}

\subsubsection{Minimales Framework}
\label{sec:org0cdbc58}
\subsubsection{Anbindung an Datenbank ja / nein}
\label{sec:org046d777}
\subsubsection{Nützliches zur Recherche}
\label{sec:org5287fb3}
\begin{enumerate}
\item ICIJ Investigations Methoden
\label{sec:org14cbaf9}
\href{https://www.qwant.com/?q=neo4j\%20panama\%20papers\&t=videos\&client=ext-firefox-light-sb\&o=0:0eb4ea4e93c8a1239701152c6c865599}{- Link}
\begin{itemize}
\item \href{https://www.icij.org/investigations/fincen-files/fincen-files-data-team-shares-tools-tips-and-songs-that-inspire/}{Meet the Team}
\end{itemize}
\begin{enumerate}
\item {\bfseries\sffamily TODO} Tool List
\label{sec:org16a5fe0}
\begin{enumerate}
\item {\bfseries\sffamily TODO} OxWall
\label{sec:org78bb72f}
\href{https://www.oxwall.com/}{Link}
\item Blacklight ?
\label{sec:orgf6ad3fc}
\item Neo4j
\label{sec:org7f81fa2}
\item Solr Tika
\label{sec:org0705994}
\end{enumerate}
\item Was können wir benutzen
\label{sec:org069ac39}
\begin{itemize}
\item Openrefine
\end{itemize}
\end{enumerate}
\end{enumerate}

\section{Recherche}
\label{sec:orgfee8dd8}
\subsection{Schwurbeler}
\label{sec:org85c7be4}
\subsubsection{Schild Verlag (Elbingen)}
\label{sec:org0f0711f}
Der Schild Verlag ist ein deutscher Verlag mit Sitz in Elbingen. Das Verlagsprogramm hat seine Schwerpunkte in den Bereichen Verschwörungstheorien, Esoterik und Impfkritik.
\url{https://inrur.is/wiki/Schild\_Verlag}

\subsubsection{Verlinkt Bücher vin}
\label{sec:org39687ea}
\url{https://amadeus-verlag.de/}

\url{https://www.psiram.com/de/index.php/Quer-Denken\_TV}

\subsubsection{Buch}
\label{sec:orged0f263}
\url{https://www.schildverlag.shop/de/wir-toeten-die-halbe-menschheit.html}

 Produktinformationen ``Deine Seele gehört uns''
Deine Seele gehört uns
\url{https://amadeus-verlag.de/buecher/amadeus-verlag/849-deine-seele-gehoert-uns-jan-van-helsing-herausgeber-anna-maria-valeton-autor-alexander-kohlhaas-autor}

\subsubsection{Quer-Denken.tv}
\label{sec:org4ef0662}
Michael vogt wasser
\url{https://shop.bormia.de/haus-quellen/haus-filteranlagen-zubehoer/carbonit-haus-kohlefilter-20-zoll}

\subsubsection{Holokaust Leugnes}
\label{sec:org0b701a1}
\url{https://www.schildverlag.shop/de/tatort-des-grauens.html}
Mahler sah in der Untersuchung den Beweis dafür, dass nicht nur die bislang angenommene Anzahl der ermordeten Juden, sondern die Tatsache des von den Nationalsozialisten verübten systematischen Judenmordes an sich erfunden sei, und wollte die strafrechtliche Relevanz dieser Aussage klären lassen.[3] Die Ermittlungen von fünf Staatsanwaltschaften wurden wegen „mangelnden Tatverdachts“ eingestellt, federführend von der Staatsanwaltschaft Stuttgart mit der Begründung, dass „sich der Beschuldigte in seinem Aufsatz klar von jedweden Bestrebungen, den Holocaust und seinen Schrecken zu verleugnen oder zu bagatellisieren ab[grenzt], indem er am Ende seiner Ausführungen ausdrücklich darauf hinweist, dass das Ergebnis seiner Untersuchungen die Barbarei nicht relativiere, sondern verifiziere.“[4]

\url{https://www.booklooker.de/B\%C3\%BCcher/Rudolf-Krohne+Kaperfahrt-Kreuz-und-quer-\%C3\%BCber-die-Meere-Reihe-Schild-Hefte-Nr-11-Kameraden-im-Kampf/id/A02cPxLg01ZZ8}

\subsection{Personen}
\label{sec:org2d6205f}
\subsubsection{Maasen}
\label{sec:org86a69d3}
Höcker
\subsubsection{Friedrichb Merz(CDU)}
\label{sec:org1d1b19e}
\begin{itemize}
\item VCI
\item Atlantik-Brücke
\item Blackrock
\item Wirtschaftskanzlei Mayer Brown LLP
\end{itemize}
\begin{enumerate}
\item Interessenkonflikte
\label{sec:org8a3ae4f}
\end{enumerate}

\subsection{Lobbygruppen}
\label{sec:org16f53c0}
\subsubsection{{\bfseries\sffamily TODO} Banken}
\label{sec:org9815ae9}
\begin{enumerate}
\item Blackrock
\label{sec:org160ed91}
\end{enumerate}
\subsubsection{Auto Lobby}
\label{sec:org90ed13a}
\begin{enumerate}
\item Verband der Automobilindustrie
\label{sec:org8f574fc}
\end{enumerate}
\subsubsection{Pharmalobby}
\label{sec:org4d6957c}
\begin{enumerate}
\item Verband der Chemischen Industrie
\label{sec:orgfc59470}
\end{enumerate}

\subsubsection{Vermieter}
\label{sec:org6b08bbc}
\subsubsection{{\bfseries\sffamily TODO} Waffen / Metal Lobby}
\label{sec:org1868499}
\subsubsection{Lebensmittel}
\label{sec:orgda0139c}
\subsubsection{Antroposophie / Esotherik}
\label{sec:org18bb358}
\subsubsection{{\bfseries\sffamily TODO} AFD / NPD / Die Rechte}
\label{sec:orge3bc452}
\subsubsection{Steinkohle \& Braunkohle}
\label{sec:orgf5c8648}
\subsubsection{Erdöl}
\label{sec:org459975f}
\subsubsection{Zoom \& Microsoft}
\label{sec:org7972057}
\subsubsection{Facebook}
\label{sec:orga1516ea}
\subsubsection{Google}
\label{sec:org39f1806}
\subsubsection{{\bfseries\sffamily TODO} Neoliberale Think Tanks}
\label{sec:org65484df}
\subsubsection{Medien}
\label{sec:orgd013543}

\subsection{Weitere}
\label{sec:orgb07ec6b}
\subsubsection{Astroturfing}
\label{sec:orgeb51c2f}
\url{https://lobbypedia.de/wiki/Friedrich-August-von-Hayek-Stiftung}
\subsubsection{Völkische}
\label{sec:org69dde95}

\section{Quellen}
\label{sec:org4a03e08}
\subsection{Lobbypedia}
\label{sec:org27a0754}
\subsection{Open Corporates}
\label{sec:org664a9f3}
\begin{itemize}
\item Adresse
\end{itemize}
\subsection{Hochschultwatch}
\label{sec:orgfc16d40}
\subsection{BUND / Kohle Statisken}
\label{sec:org7a4e5e1}
\subsection{Wikidata}
\label{sec:orge58c8c0}
\begin{itemize}
\item Familie
\end{itemize}
\subsection{Telegram}
\label{sec:org2dd1464}
\subsubsection{Link sammlung um Gruppen wie idz zu mappen}
\label{sec:org2284bb4}
\begin{itemize}
\item \url{https://github.com/paulpierre/pp\_deviantspy}
\item \url{https://github.com/Nhoya/gOSINT}
\item \url{https://github.com/twintproject/twint}
\item \url{https://gist.github.com/mneedham/fd0aece612896b8ef7cabd2943d6d90c}
\item \url{https://github.com/neo4j-devtools/neuler}
\item \url{https://github.com/sparkyvxcx/telespier}
\end{itemize}
\subsection{Twitter}
\label{sec:org2b9393d}
\begin{itemize}
\item \url{https://github.com/mneedham/kafka-connect-neo4j}
\end{itemize}
\subsection{Facebook}
\label{sec:org57203e9}
\end{document}
